/*    */ package com.qmsk.business.member.memberServiceDetail.dao;
/*    */ 
/*    */ import com.qmsk.business.sys.basic.SupportDAO;
/*    */ import com.utils.gson.in.GsonHeadOneRow;
/*    */ import com.utils.gson.out.GsonEbRst;
/*    */ import java.sql.SQLException;
/*    */ import java.util.Date;
/*    */ 
/*    */ public class MemberServiceDetailDAO extends SupportDAO
/*    */ {
/*    */   public GsonEbRst getGsonOfMemberId(Integer memberId)
/*    */     throws SQLException
/*    */   {
/* 25 */     Object[] params = { memberId };
/* 26 */     return getGsonOfParams(
/* 27 */       "selectSqlOfMemberId", "selectJsonOfMemberId", params);
/*    */   }
/*    */ 
/*    */   public Integer insertParams(Object[] params) throws SQLException {
/* 31 */     return Integer.valueOf(update("insertSql", params));
/*    */   }
/*    */ 
/*    */   public int deleteMemberId(Long memberId) throws SQLException {
/* 35 */     Object[] params = { memberId };
/* 36 */     return update("deleteMemberId", params);
/*    */   }
/*    */ 
/*    */   public Integer insertDetail(Integer validDay, Date greatTime, Date validTime, Long lMemberId, Long shopId, Object LevelID, boolean bDeleteHis)
/*    */     throws SQLException
/*    */   {
/* 49 */     if (bDeleteHis)
/*    */     {
/* 51 */       deleteMemberId(lMemberId);
/*    */     }
/* 53 */     Object[] params = { validDay, greatTime, validTime, 
/* 54 */       lMemberId, shopId, LevelID, shopId };
/* 55 */     return insertParams(params);
/*    */   }
/*    */ 
/*    */   public Integer deleteOfMemberId(Object[] objects) throws SQLException {
/* 59 */     String[] head = { "memberId" };
/* 60 */     return Integer.valueOf(deleteHeadData(head, objects));
/*    */   }
/*    */ 
/*    */   public int deleteDetail(Long lMemberId, Long shopId) throws SQLException {
/* 64 */     Object[] params = { lMemberId, shopId };
/* 65 */     return update("deleteMemberSv", params);
/*    */   }
/*    */ 
/*    */   public GsonHeadOneRow getServiceCount(Integer serviceId, Object shopId, Object memberId) throws SQLException
/*    */   {
/* 70 */     Object[] params = { shopId, memberId, serviceId };
/* 71 */     return getOneRowOfParams("selectSqlServiceCount", 
/* 72 */       "selectJsonServiceCount", params);
/*    */   }
/*    */ 
/*    */   public int updateSurplusTimes(int shu, Integer serviceId, Object shopId, Object memberId) throws SQLException
/*    */   {
/* 77 */     Object[] params = { Integer.valueOf(shu), shopId, memberId, serviceId };
/* 78 */     return update("updateSurplusTimes", params);
/*    */   }
/*    */ }

/* Location:           C:\Users\Administrator\Desktop\新建文件夹\WEB-INF\classes\
 * Qualified Name:     com.qmsk.business.member.memberServiceDetail.dao.MemberServiceDetailDAO
 * JD-Core Version:    0.5.3
 */